package com.zhongyi.util;

/**
 * 系统常量配置类
 * <p>
 * 
 *
 * @author <a href="mailto:lysongfei@gmail.com">songfei</a>
 * @version 3.0, 2012-4-24
 */
public class Constant {
	/* 企业基础信息全字段INSERT语句*/
	public static final String CORP_INSERT_SQL = "insert into td_company(id,corp_name,area_id,address,origin_site,home_page,corp_level,corp_type,linker,keyword,create_time,remark) values (?,?,?,?,?,?,?,?,?,?,?,?)";
	/* 企业联系信息全字段INSERT语句*/
	public static final String CONTACT_INSERT_SQL = "insert into td_contact(id,corp_id,contact_info,info_type,remark,create_time) values (?,?,?,?,?,?)";
	/* 系统日志全字段INSERT语句*/
	public static final String SYSLOG_INSERT_SQL = "insert into td_sys_log(id,contact_id,contact_info,info_type,info_body,contact_time,remark,status) values(?,?,?,?,?,?,?,?)";
	/* 区域信息全字段INSERT语句*/
	public static final String AREA_INSERT_SQL = "";
	/* 企业基础信息全字段UPDATE语句*/
	public static final String CORP_UPDATE_SQL = "";
	
	/* 企业联系信息、邮件状态为更新  */
	public static String CONTACT_STAUTS_UPDATE_SQL = "update td_contact set is_msend = ? where id = ?";
	
	/* 企业基础信息辅助查询 */
	public static final String CORP_COUNT_SQL = "select count(1) total from td_company where corp_name = ?";
	
	
	/* 企业邮件信息辅助查询  */
	public static final String EMAIL_PAGER_SQL = "select * from td_contact where info_type = 'E' and is_msend is null order by create_time desc limit ?,?";
	
	public static final String EMAIL_COUNT_SQL = "select count(1) total from td_contact where info_type = 'E' and is_msend is null";
	
	public static final String CONTACT_IDQUERY_SQL = "select * from td_contact where id = ?";
	
	public static final String CORP_IDQUERY_SQL = "select * from td_company where id = ?";
	
}
